SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519083 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519083 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187209,169320,184838,253328,587402,563290,520322,897557,118298,601396,609056,68520,838099,457410,846644,837438,791990,284743,957341,232685,573843,965614,544141,374421,482376,235721,555446,708769,848856,308499,908283,672280,739791,102200,68324,986203,948273,360039,992730,1040206,59217,444012,822219,415836,733593,538509,76288,363964,606067,600388,271905,322065,532045,637885,421576,692573,303511,915164,478910,368321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]