SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364583 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364583 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530799,814424,967649,1012117,136828,882810,969796,176038,487827,116529,149761,186692,727410,878158,632172,968657,878142,450221,579306,268083,820494,9889,788214,76117,509589,921948,312442,92648,928701,337535,784904,22278,905642,118644,358122,544358,83038,650805,92177,833956,959485,704515,544270,996891,484895,162252,225250,1012475,241942,181390,161788,692544,753992,15372,980561,761264,879221,27862,656596,224344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]