SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465814 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465814 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937192,114477,1034198,15598,184230,943066,166731,687270,787117,214140,193178,183883,721320,608289,510307,855922,920406,637502,781507,350537,567526,510229,1012603,303795,404063,705611,1015538,855694,727125,321788,298255,558526,254964,992824,403293,996824,386156,717394,943951,510548,667033,466437,589417,38488,829597,821219,71082,436590,46189,796010,394936,621906,572520,864644,371109,785057,104091,504226,599246,355379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001665s ]