SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030975 LIMIT 1 [ RunTime:0.000585s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030975 [ RunTime:0.004050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407947,970051,522605,980378,324093,168993,927863,629218,440126,867995,1001827,818266,387899,686372,566914,606892,280378,359638,114439,259275,372179,286590,248391,186234,511082,880127,273986,845998,1030618,746462,326296,245346,395641,582690,160845,931254,733587,566136,381982,222160,407407,529073,33926,1042530,222145,937571,679651,825203,758489,957837,901321,152147,763858,97496,881276,1011712,877645,587667,332158,155351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]