SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415771 LIMIT 1 [ RunTime:0.000690s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415771 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385395,580178,753002,676707,991634,386775,820675,615262,352912,1025875,818743,994325,328394,932645,332261,268026,288006,565210,627295,263045,604373,386984,707618,224634,295188,752747,644248,502164,442332,35289,917864,176817,193657,471980,313757,980839,724159,542861,572154,506628,593125,548324,271078,990261,312191,438358,492449,196588,771203,276744,51668,736982,87325,907286,438257,672272,472891,869035,355749,674778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]