SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019117 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019117 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517764,991076,418583,703229,313405,819601,295887,67895,448878,665855,477305,468334,923235,931253,681766,576889,930517,372705,724509,853452,186546,12769,689013,178348,77584,249694,149901,286981,569752,926950,661817,903454,844566,1036321,18006,85210,987211,873205,942772,1005708,93245,433677,477835,964992,788489,628610,697929,563013,826930,361714,1040265,769946,920681,990894,609682,287830,872777,188695,799396,955732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001668s ]