SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4029 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4029 [ RunTime:0.006067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603180,622915,507126,308703,352311,535640,718555,434270,475340,32107,779991,369045,759032,819396,275248,138009,904441,89454,714777,582619,305946,210712,782050,374867,171897,321479,460846,544737,40907,327197,604228,926841,265758,639918,755201,125191,796967,944419,830914,389147,822264,53189,595814,918359,1038733,933745,633207,264398,846366,326232,663557,767565,357512,86029,674674,794158,1007993,1036190,400332,912753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]