SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523096 LIMIT 1 [ RunTime:0.001926s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523096 [ RunTime:0.006810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76943,450410,357975,903147,323490,1010282,886897,237471,774881,348838,764451,257900,605134,320072,896057,377116,243459,466320,539959,251815,559320,80280,132413,361670,736542,106583,22027,1011234,641736,6291,414148,676998,133245,143302,1021761,81703,664194,759670,787381,369620,927189,889439,148197,932603,1015856,949648,676468,756706,1047197,1028629,592168,594633,200439,1009027,880910,336471,203126,200465,169722,525326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001768s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001215s ]