SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197899 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197899 [ RunTime:0.004517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121599,62744,173798,912412,27907,777375,361421,841856,757748,820336,428480,598339,737887,902586,1003038,825743,955139,731550,210886,303823,718389,721804,605672,664951,142942,441083,245815,659791,958538,61483,852809,494138,486829,675639,861983,1013968,59400,17588,905263,816463,787258,193155,668859,187923,371774,936493,146491,124136,900495,142628,679330,880250,579985,275086,533191,1039587,991846,294509,697278,860758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000893s ]