SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340808 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340808 [ RunTime:0.002464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960872,238174,569450,427046,773626,250457,467613,281604,153279,1006108,228047,274182,459899,953740,1011291,626239,596368,184512,694051,102389,61571,56344,106365,957550,461674,185348,212457,171328,680309,394362,669152,192690,133850,765997,900840,300600,453098,349413,738726,887790,914710,670265,491929,540570,979028,815415,312554,240223,62066,17021,143083,548495,929014,899509,927921,729048,444788,467425,875082,651648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]