SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320683 LIMIT 1 [ RunTime:0.000541s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320683 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767530,560105,1025585,491419,402862,780239,588556,75328,890310,519078,908871,819077,683013,456535,387666,634262,183499,809229,842949,1017079,892914,536724,489149,664981,251130,876910,234236,576049,343705,835336,233141,150374,850550,646019,437796,200323,665392,386156,862677,986031,176578,546025,97403,818573,965788,122682,1025164,261254,626604,248903,131315,839815,325991,11123,28401,176034,411954,987753,592105,260352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]