SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501650 LIMIT 1 [ RunTime:0.001712s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501650 [ RunTime:0.002726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264045,400847,831436,340441,751064,646491,143710,626914,312971,485675,904760,630486,134165,179922,96972,570394,464419,222985,1009434,86492,198678,944246,982201,583445,939680,369895,31875,919000,723710,57562,662277,692725,962835,631758,622488,273557,679954,189952,501325,731459,360021,80204,853823,989707,433197,928904,136080,719690,791106,923130,499950,169561,605272,538056,244568,633029,976389,717142,884055,854814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002578s ]