SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263250 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263250 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014573,13980,741292,116974,988830,1025304,494806,632600,232073,392292,98297,799406,184348,824212,428900,742251,904010,822355,220000,352877,780193,892545,618474,8457,715772,68187,353001,867563,918606,1010552,703645,136991,664850,1027307,775308,562149,417628,915124,758283,547360,426450,490954,33662,739827,349738,525263,246581,845667,1044922,149009,18140,383889,224780,2706,967739,894502,184399,1025898,585028,196904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]