SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018438 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018438 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30927,71590,1030098,1017085,471681,701957,340101,121489,312082,967510,365754,554133,315296,1003175,522387,863157,445540,485699,153719,762043,738262,376416,373283,635643,258450,270889,793426,209644,159345,524882,1017144,611965,956771,51321,614757,414792,226177,1037504,88345,456803,187076,396438,564454,440543,626347,751520,820483,886961,558986,25111,537626,866269,674136,915365,579261,516383,705409,756220,790210,290506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]