SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501660 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501660 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435984,985692,651997,503884,926506,533781,684682,775797,910698,345593,522643,800342,328994,915501,651405,337585,905299,674989,145123,79101,179338,966909,474987,330625,443564,111220,882938,31082,88367,794951,1045722,434427,903992,517186,631356,1034726,15047,706328,352649,56016,561597,360949,203322,676246,173098,117174,443981,304539,355381,457624,408427,8144,349094,620911,468832,496126,241459,518048,254362,761687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]