SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508992 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508992 [ RunTime:0.005186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495037,649477,1020147,560654,926509,978041,661730,948707,690015,1013350,583760,536157,1041014,101264,948504,298178,818619,468367,575163,117450,381891,976529,148974,415125,1620,953285,719328,23800,111789,265340,494007,175472,45248,607831,541148,478125,926856,803825,1016490,755212,686652,311043,440699,721526,627427,950952,722766,986827,531291,266929,740114,1014121,571841,1032650,667416,815356,144711,579397,255667,894089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001535s ]