SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002888s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541460 LIMIT 1 [ RunTime:0.001151s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541460 [ RunTime:0.003068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507329,1030553,161722,336904,4689,124610,1037258,515394,94415,115385,98512,512687,265071,948398,228146,223633,899261,482615,169898,1021262,484505,2716,720736,390218,657969,1043705,1048861,618584,195079,709056,420582,57593,68849,862576,115503,657597,335976,459789,845523,958896,687553,75943,993235,239042,971453,1017398,273012,302903,1037510,8992,379990,920471,396534,493268,1019838,661643,823535,482190,534480,688423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]