SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042139 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042139 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107556,836094,945578,321103,703371,337601,793752,443035,833341,779386,404613,268094,292038,318051,332858,903119,825767,442774,1041962,58754,1005957,348914,762584,859361,3010,185505,617295,961051,524121,534395,432553,706239,11073,940281,295111,458515,587092,9638,552743,603110,460399,177994,283444,186560,1012682,209685,663690,37029,113065,66704,985004,153481,637445,110814,391365,583349,863725,363934,307923,1041922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]