SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35996 LIMIT 1 [ RunTime:0.001354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35996 [ RunTime:0.002284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038915,606914,745392,259360,60907,735385,755153,340125,304097,116467,833802,957516,461666,906511,745467,328483,539585,460987,160954,460264,650180,608039,1019473,522537,997810,562864,358428,89550,784432,912869,901613,735366,621612,620962,193684,809490,463570,243465,919314,511179,200893,540271,681385,594137,185454,1002208,148568,10022,105481,705566,484300,932733,665528,819967,635565,77410,760199,841626,774373,231834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002757s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000878s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]