SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205601 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205601 [ RunTime:0.001453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981920,908196,439392,962623,487409,749502,970040,885162,580146,984812,996509,174752,963281,719825,400102,1005668,401144,957815,439761,210671,734830,700187,696065,270933,412791,493720,617476,169839,653502,76757,800067,1013829,565171,419318,79421,450389,314393,120913,945823,652458,634961,852660,488430,483979,457847,576774,563006,451931,661678,480546,394416,491282,870243,829960,270271,914043,895709,308608,491773,588320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]