SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444341 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444341 [ RunTime:0.001394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000577,160793,471728,235960,787876,444062,243260,846916,497816,254994,82647,740308,340081,596239,985563,274782,819542,590424,844922,766425,814500,277359,762273,353972,516677,273767,891754,228372,355709,489541,227932,156857,526156,971777,248736,762756,947252,739689,164950,155004,792867,673053,1034359,20583,603915,177645,781430,526086,914713,567937,221429,304215,741289,553554,529555,643209,882133,638803,413432,112792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]