SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002862s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419466 LIMIT 1 [ RunTime:0.000938s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419466 [ RunTime:0.003838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861663,191217,124370,801010,498089,729360,752864,380805,838155,396738,510758,984218,390917,586522,587644,880451,575264,883434,1031599,933321,738060,973449,364734,443624,470156,729902,599790,838320,758031,428079,5396,56081,790914,476037,80254,576596,786877,496095,844581,641228,487550,702173,481706,214825,682053,145857,376460,280712,857376,218013,432324,953055,319503,459315,725342,788607,170914,821382,285899,799516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419466 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419466 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]