SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537093 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537093 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032527,784648,519161,1028538,561254,486961,514613,757545,412108,727646,261042,812348,650034,425173,128237,809989,391526,481251,146800,449482,12534,338787,119829,589760,855361,132042,65269,38878,678406,201835,254648,331002,921940,1022642,591395,703959,168954,415807,948042,391327,528357,33377,920377,328311,550660,399948,274373,102524,69585,913644,169913,879667,743083,188610,734046,330308,455556,102536,74762,865110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]