SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 929613 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 929613 [ RunTime:0.003164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275572,262998,176606,34660,689985,447561,849953,648120,801201,4134,735857,564947,299741,201704,132251,497954,697447,589371,520518,611457,937050,889145,680496,165856,345477,960706,774177,777198,229270,647846,1014840,819051,62238,1048401,778536,508751,21201,265619,680248,905484,351488,287440,548496,892246,635808,18283,586662,51974,478270,852287,535816,125933,963276,928334,762192,479141,722721,714603,506204,130573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 929613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 929613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]