SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418601 LIMIT 1 [ RunTime:0.001804s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418601 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701594,12245,494487,548143,702580,1045011,961617,652583,201442,848422,706904,977,211811,228716,541684,832452,790580,942165,564602,166032,575005,706883,474485,504526,274540,76872,486849,647295,843209,679763,953293,558086,189393,798171,967961,494164,918770,755772,425104,489792,922694,734177,365673,995006,628363,2432,392576,92758,739278,442560,791895,586198,446034,858814,766592,505140,557961,258632,253379,970417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000958s ]