SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410313 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410313 [ RunTime:0.006632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416099,829509,798271,794971,97240,459013,110857,206344,142960,1020270,38168,834047,50496,221488,127735,290943,578610,399444,117279,1004124,830403,969449,265698,764800,562578,189089,269,997428,19499,333326,970736,596821,725174,915025,778660,217445,1033451,912005,976383,1006948,777389,658997,253636,241770,721848,773840,167218,415933,360514,1008631,189589,313595,370532,140438,926577,405354,373801,553242,665682,832390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]