SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417625 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417625 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529501,999292,678040,545162,372708,469235,495638,463722,872928,514798,607497,122652,609758,566921,927932,831913,364049,422627,829313,385129,554657,193919,484595,285759,1025777,452952,136529,478366,554570,474126,162731,823287,938358,627553,326474,409292,742038,922112,483870,674374,353333,484661,129008,474494,450143,880565,478196,34819,1039675,634876,132709,66650,450335,559023,277415,751961,569036,362073,507813,901033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417625 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417625 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]