SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002977s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513081 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513081 [ RunTime:0.003360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934144,273332,940308,359174,357196,180121,151215,205570,117331,284790,5960,149828,43679,23588,216055,465021,599593,175679,359884,878791,990338,661468,28522,152056,1018185,301991,463712,440453,1003320,886784,1009411,874342,942375,1033541,52693,1033406,183647,712974,977216,11441,892207,518053,8860,492386,825624,204814,513196,431364,13288,1016027,459886,760279,472330,892666,1011557,158340,910333,347742,457049,203732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]