SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027805 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027805 [ RunTime:0.003307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467969,606610,424926,238921,186612,894287,287315,329878,83063,295318,479253,353061,718329,12413,834693,437133,403007,403952,624407,108666,299456,639502,70532,158797,754710,1025826,497494,532547,406960,1046650,687278,375961,738255,1045544,935001,663463,272587,289699,783869,142213,741499,990514,866050,218711,400800,726767,446581,600418,1017397,162436,404551,470223,909275,1005423,350557,690425,352878,946536,148617,721774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001976s ]