SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419800 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419800 [ RunTime:0.002979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78117,437010,661130,745991,73997,289940,888528,427006,193738,831952,862324,431336,195194,1006569,431668,168668,729094,372977,983879,848308,287995,832824,416871,589793,399595,651428,972139,278693,259480,279540,554069,715023,594874,5691,936342,8088,831546,755811,662829,196760,752268,5261,973264,349582,573549,628212,236802,624068,366257,460895,272334,893328,1018531,607823,632768,536006,188102,1035584,482192,705624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]