SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53136 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53136 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11039,412178,916573,1040463,584044,267751,427653,417066,51595,853193,506584,32055,132449,66939,554435,361482,288224,614286,377609,733610,557005,846578,282589,962343,1011468,377673,828722,15416,730531,1032154,237099,77637,235327,942140,901726,143001,672840,403851,25558,922929,431018,814413,809170,9583,1005131,404756,517467,866372,981456,271069,303327,271748,588494,883253,714198,509294,1005208,374047,1026711,297875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]