SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008047s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104539 LIMIT 1 [ RunTime:0.001061s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104539 [ RunTime:0.006906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371305,851459,918008,339537,195914,641567,474905,951067,463226,677765,938184,431670,45581,864873,956447,113439,55332,10462,805387,622880,78640,146060,534743,84027,603112,927415,121398,529485,277652,773142,385600,787846,570554,52375,619484,833187,67067,725394,1042401,252299,1046469,510553,234103,139215,731260,21470,231279,603667,730509,399974,151082,896263,749836,217209,189497,297727,937214,1006530,795258,1020867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003859s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]