SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004453s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512968 LIMIT 1 [ RunTime:0.004414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512968 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204960,397506,945999,1027685,477921,808651,73726,495868,245047,272496,29648,278992,828823,348870,65320,922811,428825,684274,105120,103633,1021664,241344,490673,913442,178317,435718,165381,1024528,39464,320406,336993,624763,809401,849115,419719,628980,205292,230740,130513,475191,420208,719008,768312,775830,373861,947434,845404,11850,693799,118127,18584,442498,779623,630389,332263,92042,169560,834706,693096,929481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]