SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39601 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39601 [ RunTime:0.004929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970653,427466,252522,323719,182984,319135,124130,1022682,687454,956497,673460,427308,350622,982551,58050,703982,223721,298347,966445,962588,16796,899088,498936,924325,652312,420624,361095,695588,917157,4509,579085,198659,685195,381656,735052,708576,179048,748759,819937,979890,155981,677105,659709,527688,663581,42367,159954,125725,646364,1037099,839249,377411,48484,941457,525411,182316,952546,475846,410047,59840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]