SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338183 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338183 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395960,238420,178750,756376,200110,926438,170658,835807,486182,142794,243773,520504,718874,25610,37052,290172,920872,424753,358676,501642,572382,71782,792582,1028392,38892,498691,528523,673648,970132,752434,920696,111683,598539,939981,712624,520081,158954,579554,913925,19978,322345,604438,492714,311308,319304,399858,286302,393626,478398,547221,715785,270562,260195,468899,771733,644777,549894,191354,633427,791073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]