SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505570 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505570 [ RunTime:0.002252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886483,211888,24571,948353,41625,317819,584565,394997,872572,120895,663997,773250,829734,427459,82266,1003544,114041,290457,420193,813387,1022359,331284,640733,217877,403901,787002,897429,709213,320320,671804,524965,997418,899618,261222,327306,689160,870727,600783,521526,703935,401734,590253,1006982,565682,1046475,252,147697,970713,31169,549215,718825,196398,892315,254015,521774,938417,321165,356082,66627,992863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]