SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39649 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39649 [ RunTime:0.003950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812795,241438,15297,546707,652927,835567,934050,102029,854925,70357,722309,605495,606974,979064,699395,1030181,572207,270854,4953,982401,422862,1023535,585179,908712,632229,429650,827241,260197,788415,571088,505032,624575,759434,281204,502661,324167,94494,536507,272827,78322,600434,227821,47120,47533,260695,486782,504623,1046084,139669,116113,614026,876467,241590,953192,190085,798987,413061,864943,749454,476622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39649 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39649 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002936s ]