SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100202 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100202 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494242,534633,643101,295126,354229,256688,366681,792912,659925,960184,508938,608779,813957,57774,723431,496737,557215,202393,310620,550467,185605,171745,527461,881597,103559,222250,452262,162444,864538,921850,416058,1014063,931387,941472,961102,91577,815567,907688,1008833,303606,248334,476510,827157,792852,59037,257046,640851,269372,356389,337174,95142,247740,160003,971710,715951,84512,886706,704436,1039660,893964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]