SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405358 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405358 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711241,523312,715056,972695,1018279,342204,657240,68098,244713,677570,962315,592010,125393,581554,668808,636891,586290,195520,650070,1039346,649452,392038,614337,918084,302606,908142,309704,758940,555980,155257,591047,947212,868044,48961,671531,722026,88967,405211,829877,247481,621363,445964,451990,282669,706764,313547,371814,219879,803805,782464,564272,764659,150243,957098,551571,933887,196081,467944,567686,679193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.030571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001253s ]