SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023145 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023145 [ RunTime:0.004524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314900,979944,974404,911718,257072,33947,942190,760443,618508,256767,463661,633862,835020,474065,537940,866201,349388,28338,109440,940149,911398,519482,476839,568967,881615,813817,528156,950126,419132,551611,74350,167030,544359,386712,296959,697435,947457,212797,940942,759156,995194,146325,309949,70605,787289,251727,83517,800048,950373,143770,222610,904901,45509,515971,845878,706587,761172,178920,965865,921824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005474s ]