SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036748 LIMIT 1 [ RunTime:0.002655s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036748 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171887,180767,857420,751083,523757,19122,180884,697161,905441,520065,886625,914288,403329,32877,681194,990714,559640,593085,65547,407462,99957,599513,403083,542286,848751,270422,408140,230282,662034,71947,524592,954563,679609,523748,680871,218334,699894,212096,996712,632156,460315,220842,434767,669452,469964,342213,593065,224746,344989,909453,460163,359461,121818,213578,18563,401642,337123,359828,1006262,601166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]