SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423137 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423137 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744118,118185,452785,127312,587202,677465,260816,647949,102262,925997,840810,873897,768280,971329,504669,849515,880711,88033,714189,1038962,1037927,355276,878630,327218,824194,919136,928765,336019,431167,988732,503656,964476,1046159,1033002,266190,265104,892786,807946,568043,117086,834836,909475,1014935,479082,267764,40062,964312,225206,1011242,1023838,398161,1035370,629599,792803,401225,22443,412440,615980,275448,795566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423137 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423137 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]