SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292526 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292526 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912228,728307,493122,632234,804780,1017007,130100,383464,675017,505224,754135,177072,369220,764648,947159,872299,636459,1001308,730340,44483,722830,182873,846598,13349,890468,774435,506818,120803,1045990,973507,1039361,131607,704243,642470,610732,557669,1004523,360099,31486,618333,380454,797778,261825,78696,567250,23808,732452,968406,853573,571492,28020,980744,171583,857224,1013072,417428,701396,112678,287237,654431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]