SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106748 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106748 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249359,850426,868196,418609,517019,787841,554874,145696,257919,328479,929649,733315,825576,872345,534134,760376,432780,106914,890562,556952,1018645,889155,590912,173407,900746,23615,820478,933282,1027362,911461,913773,230291,811219,829465,734892,661525,282820,1041039,118746,476817,315882,725866,600089,1030230,706680,753605,949704,463955,836699,608762,187835,807652,249009,619112,328906,376117,628808,710164,159285,64540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]