SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534513 LIMIT 1 [ RunTime:0.000625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534513 [ RunTime:0.002247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318895,434828,345076,549719,159837,997944,937865,331174,501427,1003300,124917,728707,715026,543263,291865,178991,529469,252372,1041930,868414,5074,390185,852097,72355,830678,294870,637002,491577,147917,500609,742948,406379,73661,1018981,775825,715641,635246,230765,302887,958044,284213,342418,456652,129644,266192,623024,516928,100502,757333,474333,901159,263029,492417,537068,470849,697784,830856,486922,27029,1043440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]