SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 256083 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 256083 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958983,609841,427477,498539,984120,967175,335818,284928,995019,859801,323823,791265,942757,142533,814828,193174,985885,904958,884544,698459,18619,583637,1017115,90407,525432,765053,347276,898964,708276,496746,815157,562780,887109,389248,581932,11903,691162,7837,259770,108172,714804,935949,376830,44919,637884,300412,845568,676605,65865,261371,320638,296250,787175,487277,997591,898271,619781,121414,290819,499634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 256083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 256083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]