SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534254 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534254 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (66314,1043011,155429,382035,300011,730684,220676,763629,290077,502227,34637,9041,797068,1044660,30100,202888,159704,243240,854595,3512,1016059,909694,392695,831331,816761,463475,489113,80310,110449,349857,261664,764324,923394,417828,887983,645164,498656,712552,1001094,344735,116815,424288,732174,283528,711548,807001,596106,1026750,996912,960971,601232,958043,970517,53453,943185,834605,50820,686073,45884,567010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]