SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575120 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575120 [ RunTime:0.003181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863549,990109,294462,672441,537719,619081,566387,360008,985789,791876,148579,547347,108836,406666,635354,361998,761292,139757,599402,480637,299086,1044,676055,412651,842069,489455,606261,26789,713890,362955,927169,1001485,70502,432855,436228,696840,384087,739007,540368,914512,446861,971924,801129,533800,686208,627725,210146,191782,954556,285488,534465,128248,988543,803233,364864,1025358,473591,6090,429451,655713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002800s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]