SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40918 LIMIT 1 [ RunTime:0.000554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40918 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809156,177074,677500,1013099,652982,171337,633452,813975,909108,667044,301790,618383,170756,360489,764410,929054,323500,565845,739264,190007,167370,482064,575327,989657,601655,724484,893552,999408,535883,571648,842884,973761,1015868,278158,382393,89768,196804,628964,328279,346655,629722,981125,882256,938551,57979,725202,611673,642950,327427,89809,488959,826112,579978,50342,1148,814890,390629,145791,380775,405152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000772s ]