SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31093 LIMIT 1 [ RunTime:0.002180s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31093 [ RunTime:0.006161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398900,149894,1021587,825160,371430,226650,907287,543778,317840,293210,181452,855446,655922,4063,93121,125928,992914,966109,23027,375232,465827,371525,396666,939239,721758,25997,137463,173934,125882,212317,510535,830131,734198,279492,10460,567973,3935,443762,882207,391552,634328,556292,763167,117909,64291,963194,990151,222268,336094,573690,666844,92914,430081,118489,89643,307388,922335,106219,672673,119996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]