SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334907 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334907 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481227,308143,734411,483923,166811,245039,582415,227181,331125,160502,419393,650442,107878,254758,661260,203510,129431,137363,1020076,712882,327398,620326,692564,936991,465824,439810,643297,4343,343764,618315,649625,97469,61182,443771,291090,625533,251433,539331,112961,168192,976875,845070,977799,774433,552485,689730,654433,436645,177723,301006,414762,45907,264376,527238,610436,14537,644547,371054,1033287,609024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]