SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3748 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3748 [ RunTime:0.001474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58678,81104,808014,875268,232400,200477,905981,597230,501758,8705,351452,315275,717801,944029,881129,951653,419686,76590,145254,33980,724303,150568,1015199,828874,132494,1035532,480016,987645,24854,720877,48894,214695,88805,520021,697019,616427,593056,365327,623850,534339,642197,493955,811622,420268,72091,675955,1046517,725734,95052,747860,977673,933474,808409,361483,691994,322073,367891,980888,86236,771931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]