SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421213 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421213 [ RunTime:0.003194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605272,1009394,286201,558924,553051,28106,611135,338814,488834,999333,1039608,992035,262565,911633,787490,804046,927252,399985,205101,973136,407330,437614,474713,205183,663046,349452,178554,693432,1045510,927660,141625,970536,244312,732544,321939,1008199,84895,777287,233696,43248,144982,261087,291433,721668,478820,854821,846110,552850,467834,939765,881052,369738,261944,182520,524537,467449,555791,325346,37966,911026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]