SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001950s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040152 LIMIT 1 [ RunTime:0.001417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040152 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960412,343331,507118,598616,798823,446473,105838,1003873,473127,1025113,895989,556496,627268,44632,155977,574798,723373,929911,524515,493253,200801,131877,494892,141415,146853,174795,198682,257989,773661,805695,399008,645036,865792,38108,780545,939915,419784,548203,844687,239891,955180,312491,42371,580867,104901,855108,645718,342246,735080,111757,623294,650801,27852,521957,521441,936939,626762,137390,842679,845600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001651s ]