SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003057s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007113 LIMIT 1 [ RunTime:0.002779s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007113 [ RunTime:0.004735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246526,131757,48626,573286,704215,1018176,640397,29779,498584,387147,575318,222961,239552,549909,141527,375203,710280,975939,276506,614134,187545,739668,651286,671620,822376,300547,58649,329260,119754,956810,130220,265485,833227,576702,11019,735371,109696,727199,502098,365507,81692,203770,343876,533981,808001,182598,259596,125003,130982,804018,690049,279251,968357,440800,84891,207916,1030192,508356,300163,437182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000912s ]