SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401136 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401136 [ RunTime:0.001442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22941,252706,640830,307270,244779,770225,648538,1009189,328540,174749,294438,863505,368629,536330,159581,930973,570719,417213,277799,826751,742062,1043100,17733,161441,535292,777967,341356,489678,373236,176277,349072,538187,996482,952694,80958,680776,1020117,906548,692523,951007,896521,189579,374652,770261,775640,252581,471866,303759,313739,699510,227067,6323,212039,37692,377476,107507,833873,694005,51107,523016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]