SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105513 LIMIT 1 [ RunTime:0.000918s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105513 [ RunTime:0.002544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400163,805158,780961,100451,1045070,984359,369463,748578,183484,938690,888382,960660,327055,284854,31315,935039,896663,374430,886719,392333,897659,1007863,849733,280843,541481,724717,720787,902000,877041,636479,318533,22185,349549,443146,91993,579097,68900,835322,594246,803719,1007124,584597,666234,493859,189244,561217,241446,354510,336557,255735,717339,320121,278784,517389,310669,173305,626569,20900,279067,742604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000899s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]