SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 865409 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 865409 [ RunTime:0.002644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421913,61427,174069,404385,222530,297885,442113,30819,216478,273216,1001549,437952,174383,367598,1022360,905909,432711,835991,191828,569711,604274,507285,208587,663830,663728,416726,292025,530578,1028082,284103,823711,493936,456909,512666,1212,960673,205342,49154,815414,807714,631393,611464,510161,364095,111650,363132,699692,213289,423601,219141,389787,350815,402175,228274,1035306,360285,855885,329944,666745,434887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 865409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 865409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]