SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506875 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506875 [ RunTime:0.002308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371968,709483,805686,560613,504977,816564,633914,204063,864246,608342,1025129,266745,270580,651980,835423,119099,5560,643562,702605,421421,749938,321403,588177,1022460,726623,53811,433814,287095,233505,265464,622413,866511,270769,139751,564061,190440,252936,230322,952482,666191,130280,511372,62792,431091,607330,186016,660992,634414,103593,629220,290495,520408,29191,582059,772546,264804,174956,625886,729698,224961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001127s ]