SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204176 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204176 [ RunTime:0.002680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678736,424320,849547,793228,467345,23406,92368,272444,602519,698513,721283,790699,41160,852276,439271,321656,205802,354106,681922,856218,659678,214800,567048,78206,126138,1042356,1046124,854848,366327,917512,993657,1029880,292166,890383,9284,1004309,821902,558384,456438,806207,574155,738798,65069,51662,434690,884776,984159,586460,1032902,60150,85910,586217,330870,466019,981191,305840,74360,350458,337258,184037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]