SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476528 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476528 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149806,569231,780889,778184,798585,823210,289231,238822,1024905,734547,560539,144669,864713,648486,283734,454228,731409,485845,899285,1026271,1045978,1033910,351356,160562,68077,744187,760197,831600,607833,838039,710084,250242,884859,830886,129934,457601,443413,473021,422718,1047846,376115,786175,860523,307423,701460,721848,944444,438570,834524,57481,780291,461979,596855,840231,932683,366198,333073,8970,106087,215637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]