SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405753 LIMIT 1 [ RunTime:0.000511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405753 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350877,23323,225183,155406,134086,906118,135314,175870,141994,267414,216388,969157,968757,670384,71649,672407,912003,424845,1016870,405145,212675,833003,254502,966481,61149,521380,255641,639656,982934,429712,397982,90647,643123,150336,93867,1012093,860566,129735,832266,9329,787436,386989,160191,201915,724937,243074,309921,973125,526776,961631,1019963,386622,2225,402376,50734,634751,167083,1007708,978109,556266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]