SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566089 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566089 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923824,892418,409134,646947,901280,173452,51310,477238,80228,143098,942396,860051,1035896,16059,61870,503205,678371,775483,728335,837116,473176,696709,620240,809063,203378,1042760,698187,332125,735411,123701,909084,484409,937011,196424,728733,886362,345676,989176,337122,375120,932865,124258,234764,524363,61150,1007059,1024545,955858,389480,148680,949568,532497,743803,675382,637599,508155,803247,439397,734829,958246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]