SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047416 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047416 [ RunTime:0.003083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713013,862070,154596,299218,807237,172105,683694,199945,587775,580057,1020910,247701,1014081,88574,541357,865882,393358,798347,702350,142957,181711,191184,18819,254594,406197,204021,731619,719941,500471,820957,863477,420750,99981,582668,153150,972265,606205,455656,933003,674272,132551,142622,237392,552700,1798,547783,554243,366620,359386,536273,658341,813255,9533,806923,964554,71637,775056,877515,19278,697364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]