SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501820 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501820 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379865,938682,973707,486943,214191,952173,207423,181681,982060,272032,738764,243987,1044294,329683,25112,852453,801686,709974,114300,229614,680001,933867,640942,932998,211329,443541,671217,855226,731746,763087,180906,933463,360978,713955,587809,131548,133320,81842,473091,253939,364137,1016256,186231,147303,869624,163915,145665,277561,426357,578904,836211,70761,25005,1025030,1032531,163702,187597,757272,733575,586255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]