SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401904 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401904 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555957,940795,445162,130727,108400,840760,71949,206813,587101,440425,884194,740922,626578,696306,136652,80304,428979,836798,671269,672760,103706,441926,699574,955323,73765,1027375,441188,277381,430926,641501,470741,329112,541132,725468,290882,519813,178753,48078,143582,396118,839732,877678,263849,457457,230506,463146,198303,864554,107957,819092,264093,815798,84278,655441,175066,183516,295867,556917,961838,92780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]