SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265471 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265471 [ RunTime:0.003479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517478,995411,254813,449233,484260,531986,33866,702618,394604,565724,1000872,447696,463704,989648,440574,919707,734372,67068,409239,599435,881428,848990,361522,371640,889929,955988,1017186,691094,990398,116540,690441,434265,915682,928478,573806,693102,487192,419300,811653,732328,819607,125246,767866,196005,481880,13916,127179,214402,623745,393813,643202,885232,477874,1026345,950711,792012,487770,276410,615125,901874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]