SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 782701 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 782701 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737513,857642,906482,708141,1025724,706049,110449,321173,246621,856522,14906,441540,593426,567501,167849,752005,278850,980387,965285,185825,946016,827314,1744,421554,735115,588951,595261,992596,709814,568682,562761,559355,229540,254280,125836,855867,525121,290542,954340,80189,480656,479209,507878,204720,450525,288200,223954,867246,437010,528888,1036197,976944,153654,745054,597629,253872,571197,344248,168597,14202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 782701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 782701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000399s ]