SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534783 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534783 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75905,370390,218363,904723,1008464,812791,892548,387293,422350,882163,616482,390595,813046,167407,350694,681244,114559,349015,922452,896705,548211,968258,568625,119472,707616,871532,267496,640004,592931,616745,225113,190077,744977,257749,629791,610955,4874,561086,478937,649151,129549,422413,1001082,114583,897722,970434,557936,37929,1047007,797101,629903,331673,171767,417780,61554,958859,930038,918685,239360,194741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534783 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534783 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]