SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 973181 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 973181 [ RunTime:0.002309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006818,169965,393345,569197,132475,333565,846801,202056,506381,526381,854989,498748,459005,966316,430423,404581,314528,1011887,816566,95921,375658,785699,785577,600752,562849,681082,698389,936491,843677,684584,20017,211685,395667,324103,350362,79823,54666,871087,90496,261875,561389,441098,307890,281449,468765,167304,743125,243980,177890,558139,815015,113958,238501,645501,802884,497117,590581,22479,150511,748310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 973181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 973181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]