SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406320 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406320 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627214,807096,752134,1013514,1011496,581098,517168,226448,301542,606890,371975,2050,388336,849399,121123,1002870,166144,407591,1004769,798179,418032,278714,249894,34949,445698,593687,453219,954974,577396,108884,377570,91580,426168,116745,409677,251492,868834,935045,500987,113598,654623,845437,479826,236803,311971,661401,507575,286759,835032,508908,489179,770969,355655,551764,36492,450097,342585,394398,87487,546982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]