SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 968201 LIMIT 1 [ RunTime:0.003903s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 968201 [ RunTime:0.002693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466197,236523,14201,1044390,21209,1047858,302626,203688,182317,131040,938266,127510,724357,356950,710770,479641,744177,585086,930238,561927,1011112,1011046,925265,255393,192772,954441,256472,425275,264235,39810,978706,60144,317835,484443,700550,184878,1032993,1045066,153340,377267,385992,245993,861707,160014,670337,285778,993358,427757,120992,711117,438084,371731,33549,959697,401954,854808,1032193,40141,35029,807790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 968201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 968201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]