SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548415 LIMIT 1 [ RunTime:0.001092s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548415 [ RunTime:0.005048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006959,192432,816685,825168,144544,867040,360223,850124,827685,802388,581997,463927,504734,150910,952530,421200,341491,1025322,165889,139277,873019,526502,794047,450247,1004786,885776,494148,185541,598156,1001128,672150,897945,356329,574168,953473,231072,772738,358762,308423,854815,67668,1022003,332291,226900,997238,564103,1029807,955233,202247,1000875,620330,687092,78318,183697,893279,1047706,560435,81218,1047122,186891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]