SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001941s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 632018 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 632018 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187225,120237,999497,949005,513698,545482,797597,365726,77700,68781,253473,1043548,310633,445283,775895,871298,555490,169185,787228,655150,996904,699522,769420,173090,721537,148881,155353,266085,631713,311625,474063,551763,925125,463545,1036052,1041906,646043,392998,47363,638346,954476,468383,736442,9212,669444,35189,120684,856380,327948,55584,133184,865859,543399,391589,952893,13233,552662,179212,1024484,1012300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 632018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 632018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]