SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538512 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538512 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876730,215682,231627,854526,523520,430479,620536,617877,993961,10120,598543,883012,812566,347429,370988,970208,679133,44368,636264,546497,786225,857529,948168,367643,718506,407141,289877,625131,993995,808409,249307,557161,53585,962825,399400,813448,499566,532649,671881,155721,192452,1025249,1017168,893644,781376,121354,877297,777544,251875,128844,160109,205652,81381,1005456,596785,578451,86251,705599,74493,354680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001044s ]